Operational vs. Analytical Processes

DWH Business Vs. Analytical

QUIZ QUESTION::

Match the following examples of business processes with the type of process (operational vs. analytical) each would be considered.

ANSWER CHOICES:

Example of Business Process	Type of Process
Need to track inventory
Examine market segmentation over a period of time
Split customers into market segments for market optimization
Track financial transactions
Track shipment of customer orders

SOLUTION:

Example of Business Process	Type of Process
Need to track inventory
Track financial transactions
Track shipment of customer orders
Need to track inventory
Track financial transactions
Track shipment of customer orders
Examine market segmentation over a period of time
Split customers into market segments for market optimization
Examine market segmentation over a period of time
Split customers into market segments for market optimization
Need to track inventory
Track financial transactions
Track shipment of customer orders

SOLUTION:

is optimized to support processes for data analysis.
has data gathered from multiple sources.
is an Online Analytical Processing system.

SOLUTION:

The database schema will be hard to understand for business analysts
The analytical queries will be slow as we will have to perform lots of table joins
It might be totally ok if the database is small